Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	2969
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	301.5 KiB
Average record size in memory	104.0 B

Variable types

Numeric	11
Text	1

Alerts

`gross_revenue` is highly overall correlated with `qtde_invoices` and 3 other fields	High correlation
`recency_days` is highly overall correlated with `qtde_invoices`	High correlation
`qtde_invoices` is highly overall correlated with `gross_revenue` and 3 other fields	High correlation
`qtde_items` is highly overall correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly overall correlated with `avg_unique_basket_size`	High correlation
`avg_recency_days` is highly overall correlated with `frequency`	High correlation
`frequency` is highly overall correlated with `avg_recency_days`	High correlation
`qtde_returns` is highly overall correlated with `gross_revenue` and 3 other fields	High correlation
`avg_basket_size` is highly overall correlated with `gross_revenue` and 2 other fields	High correlation
`avg_unique_basket_size` is highly overall correlated with `avg_ticket`	High correlation
`avg_ticket` is highly skewed (γ1 = 53.44422786)	Skewed
`frequency` is highly skewed (γ1 = 24.88037069)	Skewed
`avg_basket_size` is highly skewed (γ1 = 44.68328098)	Skewed
`customer_id` has unique values	Unique
`recency_days` has 34 (1.1%) zeros	Zeros

Reproduction

Analysis started	2023-08-05 18:46:10.201216
Analysis finished	2023-08-05 18:46:40.546418
Duration	30.35 seconds
Software version	ydata-profiling vv4.4.0
Download configuration	config.json

customer_id
Real number (ℝ)

UNIQUE

Distinct	2969
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15270.773

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	12347
5-th percentile	12619.4
Q1	13799
median	15221
Q3	16768
95-th percentile	17964.6
Maximum	18287
Range	5940
Interquartile range (IQR)	2969

Descriptive statistics

Standard deviation	1718.9903
Coefficient of variation (CV)	0.11256734
Kurtosis	-1.2060947
Mean	15270.773
Median Absolute Deviation (MAD)	1488
Skewness	0.031607859
Sum	45338925
Variance	2954927.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
17588	1	< 0.1%
14905	1	< 0.1%
16103	1	< 0.1%
14626	1	< 0.1%
14868	1	< 0.1%
18246	1	< 0.1%
17115	1	< 0.1%
16611	1	< 0.1%
15912	1	< 0.1%
Other values (2959)	2959	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

gross_revenue
Real number (ℝ)

HIGH CORRELATION

Distinct	2954
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2749.2261

Minimum	6.2
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	6.2
5-th percentile	229.77
Q1	570.96
median	1086.92
Q3	2308.06
95-th percentile	7219.68
Maximum	279138.02
Range	279131.82
Interquartile range (IQR)	1737.1

Descriptive statistics

Standard deviation	10580.491
Coefficient of variation (CV)	3.8485342
Kurtosis	353.95857
Mean	2749.2261
Median Absolute Deviation (MAD)	672.72
Skewness	16.777879
Sum	8162452.2
Variance	1.1194678 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
178.96	2	0.1%
533.33	2	0.1%
889.93	2	0.1%
2053.02	2	0.1%
745.06	2	0.1%
379.65	2	0.1%
2092.32	2	0.1%
731.9	2	0.1%
1353.74	2	0.1%
331	2	0.1%
Other values (2944)	2949	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
13.3	1	< 0.1%
15	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
140438.72	1	< 0.1%
124564.53	1	< 0.1%
117375.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%

recency_days
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	272
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.288649

Minimum	0
Maximum	373
Zeros	34
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	31
Q3	81
95-th percentile	242
Maximum	373
Range	373
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	77.756171
Coefficient of variation (CV)	1.2094852
Kurtosis	2.7780386
Mean	64.288649
Median Absolute Deviation (MAD)	26
Skewness	1.7983969
Sum	190873
Variance	6046.0221
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
2	85	2.9%
3	85	2.9%
8	76	2.6%
10	67	2.3%
9	66	2.2%
7	66	2.2%
17	64	2.2%
22	55	1.9%
Other values (262)	2219	74.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	34	1.1%
1	99	3.3%
2	85	2.9%
3	85	2.9%
4	87	2.9%
5	43	1.4%
7	66	2.2%
8	76	2.6%
9	66	2.2%
10	67	2.3%

Value	Count	Frequency (%)
373	2	0.1%
372	4	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%
365	2	0.1%
364	1	< 0.1%
360	1	< 0.1%
359	1	< 0.1%
358	4	0.1%

qtde_invoices
Real number (ℝ)

HIGH CORRELATION

Distinct	56
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7228023

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.8566539
Coefficient of variation (CV)	1.5476079
Kurtosis	190.82536
Mean	5.7228023
Median Absolute Deviation (MAD)	2
Skewness	10.766456
Sum	16991
Variance	78.440319
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	786	26.5%
3	498	16.8%
4	393	13.2%
5	237	8.0%
1	190	6.4%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%
Other values (46)	332	11.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	190	6.4%
2	786	26.5%
3	498	16.8%
4	393	13.2%
5	237	8.0%
6	173	5.8%
7	138	4.6%
8	98	3.3%
9	69	2.3%
10	55	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

qtde_items
Real number (ℝ)

HIGH CORRELATION

Distinct	1665
Distinct (%)	56.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1606.4611

Minimum	1
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	101.4
Q1	296
median	639
Q3	1399
95-th percentile	4407.4
Maximum	196844
Range	196843
Interquartile range (IQR)	1103

Descriptive statistics

Standard deviation	5882.9765
Coefficient of variation (CV)	3.6620722
Kurtosis	467.15372
Mean	1606.4611
Median Absolute Deviation (MAD)	420
Skewness	17.878445
Sum	4769583
Variance	34609413
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
88	9	0.3%
150	9	0.3%
260	8	0.3%
84	8	0.3%
288	8	0.3%
272	8	0.3%
246	8	0.3%
516	7	0.2%
394	7	0.2%
Other values (1655)	2886	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	0.1%
12	2	0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
79963	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
62812	1	< 0.1%
58243	1	< 0.1%
57785	1	< 0.1%

qtde_products
Text

Distinct	2967
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Memory size	46.4 KiB

Length

Max length	39930
Median length	1493
Mean length	623.73257
Min length	5

Characters and Unicode

Total characters	1851862
Distinct characters	33
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2965 ?
Unique (%)	99.9%

Sample

1st row	85123A7105384406B84029G84029E22752217302263322632226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522173085123A7105384406B206793737021871210712106882483824868248282494L84029G84029E2275221730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105382483824868248282494L2241184029G84029E227522280321730226322263337370218712107121068824832241184029G84029E217302275285123A71053226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E21730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263384029E22752228032173085123A7105384406B3737021871210712106882483824868248282494L2241184029G226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B373702187121071210688248282494L84029G84029E2275221730226332263285123A7105384406B15056BL2067937370210712106882483824868248282494L84029G84029E2275222803217302263222633
2nd row	848792274522748227492231084969226232262221754217552177748187229602291322912229142175616161P227662270823231850158501622829227222296022961229692272022549209722274384969226222165821756217542175548184226922274822745227492296022722227202097222274849692262322499226072165847566217562175421755219022190121899219002207785123A2315223182231612316023163231622316423177231762300622996230702312623299849692165822423475662162123092231122311023111231182309323089231682323623240231752317323245230322303123029230288505322090220892208885123A217554756622423849692312620972227202315223162231632262316161P21754217552190121900481872311223111231102309323028232452324023173232362318223161231602296023546235452323122720227082298622739234352296022722227202097222621481884818448187230322303185053232452289922367235142351323511231982329423295230252347023397230962348723109234342208685049E
3rd row	22728227272272621724218831000221791210352232622629226592263122661217312290021913225402254422492210862108022726227272272822729211212232620750225512255622555217312239022333223312071921883210422236721094225402253922556225542255121981226152261622614162182232622492230072301021559210422108021086210942124021731223332233122556225542272922197220902249222991230092328023281225562249222434212402123822090227292072420719210392112121212211542098320981212458438023100212402123821244212422329822197212102235622466226102260922561227262272722728227291621823124210942108021086215592233322728210802109421086229552263622556359702198821989219872255422551220812208222080212102115621080210862109423445223262316922326224922103921210226592272622727227282233322466233282338823389233902337323374229912173122778221972336823367235062350922629215592115620750220902329822539233892235223389233882339022197207242348023570233672255522951224172197620719207242235622492226362219722083223262232821207227272272622728227302344523298212122336723368223332299121094210862108021988219892198721680223322359823084235622254022544234802308423298229092261322617235152236721156223522155922326233882272822726
4th row	22086228432284122839224232290722961225852208422423212322245722084233782312922423220772295023351233502331923354220868494622734229522301323012
5th row	212582125821258

Value	Count	Frequency (%)
charges	6	0.2%
2123221231	2	0.1%
85123a217332173385123a	2	0.1%
2248775013b85123a8248375013b2276672802a72807a20828224878248422171824838248685213228002279172351b207672280622170213132245785123a82494l170032312010133207732076820774230822306582482101352082882494l725862248820828101352245722185824838248272351a217142171323462227682188922560224892191410135170032261922440233562148535471d221122262182494l8248272351b824838248321034	1	< 0.1%
221398485422411825672167222774227717127022262226372193421169211662117537444a37444c220862208384971s7127047580222618483222644215332155715056bl15056n226462217622438217312277822719215232262022778849462103384865211722150484563a84563b2250221867216722167337444a2277585035b22775843782263722891218992208382613b82599211582208685014a374462235521258793213744935004c84559b84997d4758084415b2065522170206772123922088220902090622262221752217621243220832109837444b2193422646373332121221872212598486584997d22086226208497884050212582290984997d84997c212442067521240215592289184946226444758021470227882276622261222622156372598225028248615056bl7932135004c82494l225022082922778228442264421731228452173185184c227742290922910824864000115056n228342075022788208292177421231207192072685035b793212080248173c2075082567848362167084849d229092284522746225632256222756219492124321245206772067484997d84997c84997b826002272321832223132244585136a7932148111222422271985099b35004c21668793212208721258221982217184997d84997c824838248615056bl84563a22891215592156121558223522165884509a2173121169223842209047580217732252385036a21988219892089782613c21899848322138021670216692167121672216732226221445214472143920675826002075020829223252156321564211212277521380222412177437449217732237821240212382106884970l84970s84989a2115521243212442124522909206752067422620207332112175049l8475521672216718248484947849468515284997c84997a84997d228052277121931223558248485099f2117582599207252072722384207282071920718207242067720675206742067684997b212422210384993a21244212432124521240212392123820676212122277422775227732277222845228442257182001s207272271921774218818248221754211642280521242206762108021212212388483621121218442264584970s15056n215582103521041475802075420718207242235615056n35004c79321227782284521658843782067622352216712167321669216702167284997d84997c2072521240210682123121210210802198921242212442124521243211232175485099f2071321930219282241121934217732072521668227742167021669216712167321754218992124321244220888259984997b84997d84997c84997a84509a84510a222622184472799f206752067720674206762156185099c85099f2071922356217312284437448221972206185232a2241184520b22088215592155884997c2165822494212442124521033215592156121558206752175485099b84997b84997d2217572760b2112222494215632156484997c84997a216732167221671216702166922774217312193415056n224942247021329213282132722262227752277421669216702290822908219892250279321215232208784509c84946213132067915056n222622217084970s22171474214742222470213272263722325227882082922313217332252185032b2138085019a2186721867214392289185163b1601621755848652155785167b848322211247559b4758021035848368437821658219472194921899215632156417136a2112121122206653733321166211698258182567825832227822276211632115984912b214702146784849d84971s84997c84997a2208922090220882075084596b84596f22176216732116421987219892068522646207282210321564217332112184378222622061884949211758515285014a15056n85014b851502155672760b84559b227522224185163b221712215122152221752231822170222472189984971s2167321672216712167020750215572277222241848368518722361223632236421122222622216272760b8520085150825992116915056bl15056n2217622318222428497822778227752166922774824862192820713207122193137444b37444a84849d2226222620851872145647590a2231885205b35920848362138917136a84997a22284215638248322121359242117584949227732155884849d2194784912a15056bl15056n219302211222291222762082985185b2216235637a215633592185163b85099c223522193121673226452072522087359242145615056n217552167222771228052228485205b21380226372226284997a84997d20829219492241147580215638483285188a223552217184509a22772216712167285185b2072684849d84832222812277020733211662132784510a2065585188a21470211102144522090208292235215056n222412175584865213292116985071d82567214702208621121219472188320655213802226220665210352192921928224112166821754400012071922719228442072479321216692072585099b2072784946212402067521244210332193182001s85099b82482213138497821314226632241122385222812111022613220882290822805227732175515056n825832082947590a2066585071d85071a84849d224182242084563a2147072799f8248421240215232067721243212442067521239211652116637444c37444a84750b84849d2198721121211222153782613a851872228184997a226632224182583824868248372760b79321212388497822364228452224175049l4742147590a2277122805206552123922325222628248384997a223182278815056n85014a21470215592217120725219312072622355216682208717129f21080215234818721558216722167021673216692271922774227722217122170213862229121169217312262085232a21755219342228185150211692143921380220902208922088225258518782483213142131385099b2193622101207282131375049l2121848173c4818548111481162124222197714598497822087824838248622104848328494621989225258515221755213802173320829206658437821035215578258184912a2209022321224112103385188a22291359212275221389215632156422771228052208782494l218844758021563215642252120829213802246722778849782271917129f219313744621035214702116622089225232065584997a85200213892229122525225582275522758227562275322754227578494982613c2138085188a215642275822757227562275522754227532198722243826002208885205b21171224112319923201232052320422661232052320823206851972228115056p2145921212216692167122355712792195582001s85099b2277522355223562072320724223832072622382223842072520727207282241121929226632193020711223852103321928223862193120712211758515222670231822267122672226752267422673850532245715056n15056p2144784563a2227882613a206558494922637226202262021731223322233122333223342209022089220882208722908213272132922281847892101221564220872075021928219292241120750221752156484997a221622215184949208292213922457219342319923201851522117584832226202186485014b15056bl15056n2208821931223844000320676206742072775049l84755849787145922386207122241185099f85099b227782167321672216702166921668217922266321211219882279620750218992140884997d21380227662217584997a21731231402314121115217332156321564211662116482600232564758015056n15056bl21557226372213921033223852192822457849782316885099b2193020711224272238685099f21931207192071221929226612238322382207182308484997c2319223191231902316523167231662237946138b2320621559221522156346138b232062241122178219312213921929223862266385099c85099f22386207122237921175712702186747590b22766226612071923208475802238315056n207282082920726207242072322356212452124284997a84997b232052320885099f22386207122192985099c84510a2320422383232012209084509a85099c23208231992238621929207272071220718228962071923205207262072385099f2325622382207282238422139216702308415056bl2275284692227572275822756232052235620724207232072620725219292103385099f85099b8497875049l17129f8248422774227722277121314227782316815056bl15056n84849d82613d826002227884997a84997c71270712702115922663211692275221467211152143984997b84997d22891227582155784970s20829213802173122382220832111548194226612072722663207192303423035230332242722103714772238217129f82001s20685232042071923206207282319923201224112238685099b21928219312189984596b84596f2111521166215562117121163213802173115056n15056bl22083826002156484347212312208321559224112193185099c2308923084217311600882001s21137227552275621787214472204121175211792116923182211942120815056n2067921557223162319247590a211242319623197231982242622278223158505384596f2328523286232872328818097c228912235447559b47580231992266385099b17091j2257122572210332238647590a2156321557227522111082613d17091j15056n206792173123201223852316623165231632242623182226712303520829220452167322548217902267022409224072240622408224072217921980219832198522615224682198221984219672261647310m2071221137160084811185159a85159b219302071185014b82613d22671208292121120898218672275622753227582275722754227552262022139231822215121447212328248622905229042290323197162252319223190229082178747351b2238675049l223602303322426230352308921716217152277371477227732277422041217182142821672216692290816225224672066584347229052116922671231822319823196231971600885014b15056n15056bl21671216682152348187231682303484569a84569d15056bl15056n20711219302071282600207262072421669216682167121670216722310417129f2113722467824862124585099f2192922775232062238322384207271600821731231822319647310m208292113721718217152318222316227552240923166231672319823197223152231615056bl71459207331600815056n15056bl22316231822277547310m22178231672267084970l2221922139214242142623198231962319723198217542240622409219862179121790226702178721930223862319985099c226702198222409217872247648173c15056bl22755211372131347310m82001s2316822197220412231648173c15056bl15056n85099b2267523201225482318272802a2213547351b1600823198712702121021424214272142822406217182171621467231672308922315223642277817129f213137147775049l8497847351b23168231652284482001s21137160082275215056bl15056n22620217552175448173c21934226372308922409214302240722408224104748047471217312267022665221512275722756227582275322754227552319823197231962267221447208292217421428228918256782600211752267521425214272290422905229032179021791225482254916225224062171822560222972198721439218672065584997d84997c84997a84997b221392293922990214702070479302m21989217152171622134231542210148173c221782235221470216692277385099c2316723166223862071322674226752232622328223272232922410227552233322411207122193021929219342267522670226732267415056n15056bl2303123029230322302822758217872082922646226452318446118214282217922326227212236223403219282192922663207112241121930207122217322682226832268022681226842268522670226792268622677226712267222673226782267684406b2314723146231482082922427227582232684949221322213379066k2318247563a84912a221398483220655213292189921327224292194723016215312264422637221792116621867209862250085014b85014a213802275221684231842153023142228982289921523230892242715056bl21791222162179022904230361622522644226462192920711211662227822674226912269222414223652236685014a206792316921110850531622523190231922319122754226202278144089c44089a8434721327213292231822085226712290421380226282257185099b79066k2238621928475802268622685226812233122406843472266321561215592113720713233152331623317214272241023026231632189222310215302264422646232752264522757219342268321427212573592422227231972275522686226852267622671218822188022326214702303184970l2120721166211652232715056bl8434784510a208292213984509a2316822467231662316585159b217747145948184231692208385099c22411207122268622676226702267722679226812302923032227582327522409218122318221086223322233315056n15056bl16008226632193421121226802267623032221712267715056p2331622366226202231085014b2132921791213272117422326227582198721881223312227621530227562188221812218112186421866230312275722162475802233222333212574818479302m4818522678226832314715056bl2173122326232752303122677226862268023148222972290521232217902236684600215302303221811227552213917091j211372121022686226782268322682226762267722685212588460084510a23275226208434715056bl208292267421731222278494784347215582314822663215302275821012229042213921094207132246822905226792275822755230322217521530224262104184510a23147226718434715056bl21755215312263722386219342319622758222272155822904843752173122161226822267722678843472240723169224672125884947211372275522758231682327548173c849472242616008225562319722572225712213921879218832188121880226202193422426229622296322227221392314716008843478248684510a22753227572138015056bl15056n23031231462241115056n15056bl21773227572181122904229052290322227226852268222683226782267622671226772268022670226812268422686226792267222754227562275322673226752267423163160082318222310211212188384375231462186722175851502116421169851522117521530224682217921211211642198821557226204742120679220652296322962211372316823166231672238620712227782213922844219342193021929219282131375049l84945847924811182483824822266385099c224112217182001s217312143915056p21987843472206582486206852222723271223332115947559b2082923397481872181184347218922314821812220782101222227223652242623168207112179122152215302275422753227562275723317233152250072800e160082184422227231962318422310217872267421880218822192822663221792082921892843752242920712220832316922467725982222735001g211101601621949218998483684347211694811684970s2067979302m8505321012233972236547563a21470214282082923026232752238685099c224114818821169207182072485099b223278469223031213808520285204852032319784347233162331522265207132279415056bl2204121169843472278123315233162275584971s442354423444235227582275523197226912113721258224142152448116231692331523316233172179022678222622189222227217182171623184231962193185099b84347224108494523147231482240647310m79302m22905461188497822752212582332621313481872331723197210122222722794231822175585053231102116921258231682316721314211374423484347	1	< 0.1%
22297227712277222773228052246922197211252112685049c85049d85049e85049g21061210632106284380843782296421213224172121284992219752238320728207272229620728207252072722383223842123222646223182072720728223832238423209207252264622645212312123223089231472314682486221972265022644224692219722469207272072822383232092193185099c2320385099b2192821929824868248385130b85130c2072522384235832330122383232092246922650221972309623452234532229720725	1	< 0.1%
22086229102283722730227278248484050226054811148188206852152322278217418517437343229042153121533210682107121523847542298522983226492153922072214982149921527374482224522693847552282722030232322323122501229262250222241229572228722699219222235422721226662292684879224422244322441212012290421218214072111622730227272260522697226982269922502225012242382484218447932121187475662111421925226912121021094210802108622333220902208722088220842208321202212042296475049l84380224372120721215231092229722927224432244121114231082260721917206852329823173226992269822697227252273022729227282272723283224568248485123a22501220372320823209232032320223046231702316821094220902208822083212122108621201212042120622197212132300022999226242272623244232352324521922225052272922728227252273022727793212242322781226052320822441224432269722699232452269885049g2317384755359702310122603226022321323209231122245622767227688248622766219168248479321219222290422026220302150622983226522317023175231742242722191227262272922730230572229622297227412256122083224182219723190210802299923000220902108621094217542111422725227272269922697226242260522441232088248322766227672320922698227262324521497232327147723075230462307022792230662306521916224568248422191227212266522666214072316885123a2317323109233502339323395234122335622467232432284322841235592269323196231972150622983229852354623545793212242382484714772323223109230702328323462233562266622665226052219121497217542245623112226992269823172231712317022727227262331122732233192208623381219802337922114233562335584029g23503230002299922436	1	< 0.1%
2211022098221002276622451225498474485049e213282296117091a2247384509a84510a22767227682146321464208208515022117211694812982580825788258122413219072244121122228518499122810228092243520966209632096122068217432174484709b2159221587209922266285123a228048248320749207252238220726223842246784625c84625a21108228482103347570b84030e22428225021621884559b84559a22437224368522722983220302119921829212942233222181222712227421989230532305216259475662329821034223542132640001851072332223321233332333423332224602298323109230822103423177851771623621703210982299723501235042350222621227552183223188230842207485049c1622585123a2214422910207582343423435233112340622766227282335282616c23044224912339523393233942278523569235702357184029g2147923319233188401223531227812348621034	1	< 0.1%
22728227272272621724218831000221791210352232622629226592263122661217312290021913225402254422492210862108022726227272272822729211212232620750225512255622555217312239022333223312071921883210422236721094225402253922556225542255121981226152261622614162182232622492230072301021559210422108021086210942124021731223332233122556225542272922197220902249222991230092328023281225562249222434212402123822090227292072420719210392112121212211542098320981212458438023100212402123821244212422329822197212102235622466226102260922561227262272722728227291621823124210942108021086215592233322728210802109421086229552263622556359702198821989219872255422551220812208222080212102115621080210862109423445223262316922326224922103921210226592272622727227282233322466233282338823389233902337323374229912173122778221972336823367235062350922629215592115620750220902329822539233892235223389233882339022197207242348023570233672255522951224172197620719207242235622492226362219722083223262232821207227272272622728227302344523298212122336723368223332299121094210862108021988219892198721680223322359823084235622254022544234802308423298229092261322617235152236721156223522155922326233882272822726	1	< 0.1%
22086228432284122839224232290722961225852208422423212322245722084233782312922423220772295023351233502331923354220868494622734229522301323012	1	< 0.1%
Other values (2963)	2963	99.4%

Most occurring characters

Value	Count	Frequency (%)
2	568777	30.7%
1	193850	10.5%
3	182049	9.8%
8	140316	7.6%
9	133911	7.2%
0	129867	7.0%
4	125320	6.8%
7	121703	6.6%
5	121128	6.5%
6	104084	5.6%
Other values (23)	30857	1.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1821005	98.3%
Uppercase Letter	30846	1.7%
Space Separator	11	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	8451	27.4%
A	7546	24.5%
C	3827	12.4%
D	2101	6.8%
L	1834	5.9%
E	1419	4.6%
F	1252	4.1%
S	1160	3.8%
G	991	3.2%
P	565	1.8%
Other values (12)	1700	5.5%

Decimal Number

Value	Count	Frequency (%)
2	568777	31.2%
1	193850	10.6%
3	182049	10.0%
8	140316	7.7%
9	133911	7.4%
0	129867	7.1%
4	125320	6.9%
7	121703	6.7%
5	121128	6.7%
6	104084	5.7%

Space Separator

Value	Count	Frequency (%)
	11	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1821016	98.3%
Latin	30846	1.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
B	8451	27.4%
A	7546	24.5%
C	3827	12.4%
D	2101	6.8%
L	1834	5.9%
E	1419	4.6%
F	1252	4.1%
S	1160	3.8%
G	991	3.2%
P	565	1.8%
Other values (12)	1700	5.5%

Common

Value	Count	Frequency (%)
2	568777	31.2%
1	193850	10.6%
3	182049	10.0%
8	140316	7.7%
9	133911	7.4%
0	129867	7.1%
4	125320	6.9%
7	121703	6.7%
5	121128	6.7%
6	104084	5.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1851862	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	568777	30.7%
1	193850	10.5%
3	182049	9.8%
8	140316	7.6%
9	133911	7.2%
0	129867	7.0%
4	125320	6.8%
7	121703	6.6%
5	121128	6.5%
6	104084	5.6%
Other values (23)	30857	1.7%

avg_ticket
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	2001
Distinct (%)	67.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51.899993

Minimum	2.15
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	2.15
5-th percentile	4.918
Q1	13.12
median	17.97
Q3	24.99
95-th percentile	90.498
Maximum	56157.5
Range	56155.35
Interquartile range (IQR)	11.87

Descriptive statistics

Standard deviation	1036.9343
Coefficient of variation (CV)	19.97947
Kurtosis	2890.7074
Mean	51.899993
Median Absolute Deviation (MAD)	5.99
Skewness	53.444228
Sum	154091.08
Variance	1075232.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.49	7	0.2%
19.06	6	0.2%
16.92	6	0.2%
16.39	6	0.2%
17.66	6	0.2%
16.82	6	0.2%
15	5	0.2%
19.44	5	0.2%
15.1	5	0.2%
20.75	5	0.2%
Other values (1991)	2912	98.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.15	1	< 0.1%
2.43	1	< 0.1%
2.46	1	< 0.1%
2.51	1	< 0.1%
2.52	1	< 0.1%
2.65	1	< 0.1%
2.66	1	< 0.1%
2.71	1	< 0.1%
2.76	1	< 0.1%
2.77	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
3202.92	1	< 0.1%
1687.2	1	< 0.1%
952.99	1	< 0.1%
872.13	1	< 0.1%
841.02	1	< 0.1%
651.17	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%

avg_recency_days
Real number (ℝ)

HIGH CORRELATION

Distinct	1258
Distinct (%)	42.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.35143

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	25.928571
median	48.285714
Q3	85.333333
95-th percentile	201
Maximum	366
Range	365
Interquartile range (IQR)	59.404762

Descriptive statistics

Standard deviation	63.542829
Coefficient of variation (CV)	0.94345182
Kurtosis	4.8877032
Mean	67.35143
Median Absolute Deviation (MAD)	26.285714
Skewness	2.062909
Sum	199966.4
Variance	4037.6912
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	25	0.8%
4	22	0.7%
70	21	0.7%
7	20	0.7%
35	19	0.6%
49	18	0.6%
21	17	0.6%
46	17	0.6%
11	17	0.6%
1	16	0.5%
Other values (1248)	2777	93.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	16	0.5%
1.5	1	< 0.1%
2	13	0.4%
2.5	1	< 0.1%
2.601398601	1	< 0.1%
3	15	0.5%
3.321428571	1	< 0.1%
3.330357143	1	< 0.1%
3.5	2	0.1%
4	22	0.7%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1225
Distinct (%)	41.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.11379122

Minimum	0.0054495913
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	0.0054495913
5-th percentile	0.0088941642
Q1	0.016339869
median	0.025889968
Q3	0.049418605
95-th percentile	1
Maximum	17
Range	16.99455
Interquartile range (IQR)	0.033078735

Descriptive statistics

Standard deviation	0.40815715
Coefficient of variation (CV)	3.5868949
Kurtosis	989.35782
Mean	0.11379122
Median Absolute Deviation (MAD)	0.012191338
Skewness	24.880371
Sum	337.84614
Variance	0.16659226
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	198	6.7%
0.02777777778	17	0.6%
0.0625	17	0.6%
0.02380952381	16	0.5%
0.09090909091	15	0.5%
0.08333333333	15	0.5%
0.03448275862	14	0.5%
0.02941176471	14	0.5%
0.03571428571	13	0.4%
0.07692307692	13	0.4%
Other values (1215)	2637	88.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	6	0.2%
1.142857143	1	< 0.1%
1	198	6.7%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%
0.5	3	0.1%

qtde_returns
Real number (ℝ)

HIGH CORRELATION

Distinct	1665
Distinct (%)	56.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-1606.4611

Minimum	-196844
Maximum	-1
Zeros	0
Zeros (%)	0.0%
Negative	2969
Negative (%)	100.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	-196844
5-th percentile	-4407.4
Q1	-1399
median	-639
Q3	-296
95-th percentile	-101.4
Maximum	-1
Range	196843
Interquartile range (IQR)	1103

Descriptive statistics

Standard deviation	5882.9765
Coefficient of variation (CV)	-3.6620722
Kurtosis	467.15372
Mean	-1606.4611
Median Absolute Deviation (MAD)	420
Skewness	-17.878445
Sum	-4769583
Variance	34609413
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-310	11	0.4%
-88	9	0.3%
-150	9	0.3%
-260	8	0.3%
-84	8	0.3%
-288	8	0.3%
-272	8	0.3%
-246	8	0.3%
-516	7	0.2%
-394	7	0.2%
Other values (1655)	2886	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-196844	1	< 0.1%
-80997	1	< 0.1%
-79963	1	< 0.1%
-77373	1	< 0.1%
-69993	1	< 0.1%
-64549	1	< 0.1%
-64124	1	< 0.1%
-62812	1	< 0.1%
-58243	1	< 0.1%
-57785	1	< 0.1%

Value	Count	Frequency (%)
-1	1	< 0.1%
-2	2	0.1%
-12	2	0.1%
-16	1	< 0.1%
-17	1	< 0.1%
-18	1	< 0.1%
-19	1	< 0.1%
-20	1	< 0.1%
-23	1	< 0.1%
-25	1	< 0.1%

avg_basket_size
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1973
Distinct (%)	66.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	249.34954

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	44
Q1	103.25
median	172
Q3	281.5
95-th percentile	599.52
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	178.25

Descriptive statistics

Standard deviation	791.50241
Coefficient of variation (CV)	3.1742686
Kurtosis	2256.2455
Mean	249.34954
Median Absolute Deviation (MAD)	82.75
Skewness	44.683281
Sum	740318.79
Variance	626476.07
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
73	9	0.3%
86	9	0.3%
82	9	0.3%
136	8	0.3%
60	8	0.3%
75	8	0.3%
88	8	0.3%
71	7	0.2%
Other values (1963)	2882	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	0.1%
2	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%

avg_unique_basket_size
Real number (ℝ)

HIGH CORRELATION

Distinct	1010
Distinct (%)	34.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.155074

Minimum	1
Maximum	299.70588
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.4 KiB

Quantile statistics

Minimum	1
5-th percentile	3.3454545
Q1	10
median	17.2
Q3	27.75
95-th percentile	56.94
Maximum	299.70588
Range	298.70588
Interquartile range (IQR)	17.75

Descriptive statistics

Standard deviation	19.513033
Coefficient of variation (CV)	0.88074783
Kurtosis	27.694698
Mean	22.155074
Median Absolute Deviation (MAD)	8.2
Skewness	3.4982521
Sum	65778.414
Variance	380.75846
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	53	1.8%
14	40	1.3%
11	38	1.3%
20	33	1.1%
9	33	1.1%
1	32	1.1%
18	31	1.0%
10	30	1.0%
16	29	1.0%
17	28	0.9%
Other values (1000)	2622	88.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	32	1.1%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.333333333	2	0.1%
1.5	8	0.3%
1.568181818	1	< 0.1%
1.571428571	1	< 0.1%
1.666666667	4	0.1%
1.833333333	1	< 0.1%
2	24	0.8%

Value	Count	Frequency (%)
299.7058824	1	< 0.1%
259	1	< 0.1%
203.5	1	< 0.1%
148	1	< 0.1%
145	1	< 0.1%
136.125	1	< 0.1%
135.5	1	< 0.1%
127	1	< 0.1%
122	1	< 0.1%
118	1	< 0.1%

Auto

Heatmap
Table

	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
customer_id	1.000	-0.076	0.001	0.025	-0.070	-0.131	0.019	-0.002	0.070	-0.123	-0.007
gross_revenue	-0.076	1.000	-0.415	0.770	0.927	0.246	-0.248	0.090	-0.927	0.576	0.291
recency_days	0.001	-0.415	1.000	-0.502	-0.408	0.048	0.108	0.018	0.408	-0.098	-0.106
qtde_invoices	0.025	0.770	-0.502	1.000	0.717	0.059	-0.258	0.078	-0.717	0.101	0.025
qtde_items	-0.070	0.927	-0.408	0.717	1.000	0.168	-0.227	0.080	-1.000	0.729	0.321
avg_ticket	-0.131	0.246	0.048	0.059	0.168	1.000	-0.122	0.091	-0.168	0.189	-0.611
avg_recency_days	0.019	-0.248	0.108	-0.258	-0.227	-0.122	1.000	-0.881	0.227	-0.077	0.048
frequency	-0.002	0.090	0.018	0.078	0.080	0.091	-0.881	1.000	-0.080	0.027	-0.072
qtde_returns	0.070	-0.927	0.408	-0.717	-1.000	-0.168	0.227	-0.080	1.000	-0.729	-0.321
avg_basket_size	-0.123	0.576	-0.098	0.101	0.729	0.189	-0.077	0.027	-0.729	1.000	0.448
avg_unique_basket_size	-0.007	0.291	-0.106	0.025	0.321	-0.611	0.048	-0.072	-0.321	0.448	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
0	17850	5391.21	372.0	34.0	1733.0	85123A7105384406B84029G84029E22752217302263322632226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522173085123A7105384406B206793737021871210712106882483824868248282494L84029G84029E2275221730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105382483824868248282494L2241184029G84029E227522280321730226322263337370218712107121068824832241184029G84029E217302275285123A71053226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E21730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263384029E22752228032173085123A7105384406B3737021871210712106882483824868248282494L2241184029G226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B373702187121071210688248282494L84029G84029E2275221730226332263285123A7105384406B15056BL2067937370210712106882483824868248282494L84029G84029E2275222803217302263222633	18.15	35.500000	17.000000	-1733.0	50.970588	8.735294
1	13047	3232.59	56.0	9.0	1390.0	848792274522748227492231084969226232262221754217552177748187229602291322912229142175616161P227662270823231850158501622829227222296022961229692272022549209722274384969226222165821756217542175548184226922274822745227492296022722227202097222274849692262322499226072165847566217562175421755219022190121899219002207785123A2315223182231612316023163231622316423177231762300622996230702312623299849692165822423475662162123092231122311023111231182309323089231682323623240231752317323245230322303123029230288505322090220892208885123A217554756622423849692312620972227202315223162231632262316161P21754217552190121900481872311223111231102309323028232452324023173232362318223161231602296023546235452323122720227082298622739234352296022722227202097222621481884818448187230322303185053232452289922367235142351323511231982329423295230252347023397230962348723109234342208685049E	18.90	27.250000	0.028302	-1390.0	154.444444	19.000000
2	12583	6705.38	2.0	15.0	5028.0	22728227272272621724218831000221791210352232622629226592263122661217312290021913225402254422492210862108022726227272272822729211212232620750225512255622555217312239022333223312071921883210422236721094225402253922556225542255121981226152261622614162182232622492230072301021559210422108021086210942124021731223332233122556225542272922197220902249222991230092328023281225562249222434212402123822090227292072420719210392112121212211542098320981212458438023100212402123821244212422329822197212102235622466226102260922561227262272722728227291621823124210942108021086215592233322728210802109421086229552263622556359702198821989219872255422551220812208222080212102115621080210862109423445223262316922326224922103921210226592272622727227282233322466233282338823389233902337323374229912173122778221972336823367235062350922629215592115620750220902329822539233892235223389233882339022197207242348023570233672255522951224172197620719207242235622492226362219722083223262232821207227272272622728227302344523298212122336723368223332299121094210862108021988219892198721680223322359823084235622254022544234802308423298229092261322617235152236721156223522155922326233882272822726	28.90	23.187500	0.040323	-5028.0	335.200000	15.466667
3	13748	948.25	95.0	5.0	439.0	22086228432284122839224232290722961225852208422423212322245722084233782312922423220772295023351233502331923354220868494622734229522301323012	33.87	92.666667	0.017921	-439.0	87.800000	5.600000
4	15100	876.00	333.0	3.0	80.0	212582125821258	292.00	8.600000	0.073171	-80.0	26.666667	1.000000
5	15291	4623.30	25.0	14.0	2102.0	22114217338248482486217542242422505227682175421755217562217084406B848792113685066227962229422487481884819420685847552162121623229682275922762217564818882486222412228848185215242242482486222192217084406B221732218948138481942152448111212322125984970L22855222122224121756206858248646000S222198487922189228222152348188847557147784970L22784216732167221669216682284422852228452285348184824862167221754217552166821669216702175521670216692166822578225792257721524481882173321754217552211222577225782257922784222122221923355	45.33	23.200000	0.040115	-2102.0	150.142857	7.285714
6	14688	5630.87	7.0	21.0	3621.0	2238685099C210332072384997B84997C210942072521559223522121221975219778499184519A85183B85071B219312192922343223452234484519A48188223792238185099B2108021086219758499221210219742266784519B212162193521934219002191184849D2096671496B71495B2186521867219012186647310M218642186722090793212238122379219754811148173C2237921934223802235621900219012190222197207232072420719223552299622995229982299779302M7932147310M2237922381223802209021212461182193221937206752067621901219252193421935216212205348111223862072377101A2235677101A2143046126A2123921240212382124277101A22197210942198979321221792295320724223554611821937219362117248188231822318221034223812237948188219342197479026B22997229952189921900219022190123182219362123821866218642186521867217702117220676206772067579051A47310M2217922995229972318247310M220908482823298793212238023204229532193422356216212116521936211722235523205231822190282551825522267447310M22090793212193521934219372193621936219312238623199229532071923204217702320523182825512299622355223562177023199232012237979321215592072721930219342238685099B210332238622995229982238420728231822318222197211622116323321230802193021931223862320185099C85099F85099B231992238021934219352071920723223552320522356232042072420727207252238447310M21430793212117223321219012190021899219022295322997215582177022379219348255121935207112237921770231824611822995224672334822138217702299647310M2142722674221382261722379223812334820711221382334822467223812348523328217422246722467217702330120728231692358316258A8255221949231942324147310M23471218992190021901235011623621832162372355220986235712249123126231272227422475221912098285135C85136A2299722138214302319223182217542175621930235812238122379	17.22	18.300000	0.057221	-3621.0	172.428571	15.571429
7	17809	5411.91	16.0	12.0	2057.0	229612294322617225692256884032B84032A227492294022909226522291022585215232262421523226244813823284232982298822366214632146422334210342233310120162352243921914212202132920974218292328423382229092295022910221412214223312225852296122561231882299122992231928469223300843478434723300231882214222141232982236623300	88.72	35.700000	0.033520	-2057.0	171.416667	5.083333
8	15311	60767.90	0.0	91.0	38194.0	221398485422411825672167222774227717127022262226372193421169211662117537444A37444C220862208384971S7127047580222618483222644215332155715056BL15056N226462217622438217312277822719215232262022778849462103384865211722150484563A84563B2250221867216722167337444A2277585035B22775843782263722891218992208382613B82599211582208685014A374462235521258793213744935004C84559B84997D4758084415B2065522170206772123922088220902090622262221752217621243220832109837444B2193422646373332121221872212598486584997D22086226208497884050212582290984997D84997C212442067521240215592289184946226444758021470227882276622261222622156372598225028248615056BL7932135004C82494L225022082922778228442264421731228452173185184C227742290922910824864000115056N228342075022788208292177421231207192072685035B793212080248173C2075082567848362167084849D229092284522746225632256222756219492124321245206772067484997D84997C84997B826002272321832223132244585136A7932148111222422271985099B35004C21668793212208721258221982217184997D84997C824838248615056BL84563A22891215592156121558223522165884509A2173121169223842209047580217732252385036A21988219892089782613C21899848322138021670216692167121672216732226221445214472143920675826002075020829223252156321564211212277521380222412177437449217732237821240212382106884970L84970S84989A2115521243212442124522909206752067422620207332112175049L8475521672216718248484947849468515284997C84997A84997D228052277121931223558248485099F2117582599207252072722384207282071920718207242067720675206742067684997B212422210384993A21244212432124521240212392123820676212122277422775227732277222845228442257182001S207272271921774218818248221754211642280521242206762108021212212388483621121218442264584970S15056N215582103521041475802075420718207242235615056N35004C79321227782284521658843782067622352216712167321669216702167284997D84997C2072521240210682123121210210802198921242212442124521243211232175485099F2071321930219282241121934217732072521668227742167021669216712167321754218992124321244220888259984997B84997D84997C84997A84509A84510A222622184472799F206752067720674206762156185099C85099F2071922356217312284437448221972206185232A2241184520B22088215592155884997C2165822494212442124521033215592156121558206752175485099B84997B84997D2217572760B2112222494215632156484997C84997A216732167221671216702166922774217312193415056N224942247021329213282132722262227752277421669216702290822908219892250279321215232208784509C84946213132067915056N222622217084970S22171474214742222470213272263722325227882082922313217332252185032B2138085019A2186721867214392289185163B1601621755848652155785167B848322211247559B4758021035848368437821658219472194921899215632156417136A2112121122206653733321166211698258182567825832227822276211632115984912B214702146784849D84971S84997C84997A2208922090220882075084596B84596F22176216732116421987219892068522646207282210321564217332112184378222622061884949211758515285014A15056N85014B851502155672760B84559B227522224185163B221712215122152221752231822170222472189984971S2167321672216712167020750215572277222241848368518722361223632236421122222622216272760B8520085150825992116915056BL15056N2217622318222428497822778227752166922774824862192820713207122193137444B37444A84849D2226222620851872145647590A2231885205B35920848362138917136A84997A22284215638248322121359242117584949227732155884849D2194784912A15056BL15056N219302211222291222762082985185B2216235637A215633592185163B85099C223522193121673226452072522087359242145615056N217552167222771228052228485205B21380226372226284997A84997D20829219492241147580215638483285188A223552217184509A22772216712167285185B2072684849D84832222812277020733211662132784510A2065585188A21470211102144522090208292235215056N222412175584865213292116985071D82567214702208621121219472188320655213802226220665210352192921928224112166821754400012071922719228442072479321216692072585099B2072784946212402067521244210332193182001S85099B82482213138497821314226632241122385222812111022613220882290822805227732175515056N825832082947590A2066585071D85071A84849D224182242084563A2147072799F8248421240215232067721243212442067521239211652116637444C37444A84750B84849D2198721121211222153782613A851872228184997A226632224182583824868248372760B79321212388497822364228452224175049L4742147590A2277122805206552123922325222628248384997A223182278815056N85014A21470215592217120725219312072622355216682208717129F21080215234818721558216722167021673216692271922774227722217122170213862229121169217312262085232A21755219342228185150211692143921380220902208922088225258518782483213142131385099B2193622101207282131375049L2121848173C4818548111481162124222197714598497822087824838248622104848328494621989225258515221755213802173320829206658437821035215578258184912A2209022321224112103385188A22291359212275221389215632156422771228052208782494L218844758021563215642252120829213802246722778849782271917129F219313744621035214702116622089225232065584997A85200213892229122525225582275522758227562275322754227578494982613C2138085188A215642275822757227562275522754227532198722243826002208885205B21171224112319923201232052320422661232052320823206851972228115056P2145921212216692167122355712792195582001S85099B2277522355223562072320724223832072622382223842072520727207282241121929226632193020711223852103321928223862193120712211758515222670231822267122672226752267422673850532245715056N15056P2144784563A2227882613A206558494922637226202262021731223322233122333223342209022089220882208722908213272132922281847892101221564220872075021928219292241120750221752156484997A221622215184949208292213922457219342319923201851522117584832226202186485014B15056BL15056N2208821931223844000320676206742072775049L84755849787145922386207122241185099F85099B227782167321672216702166921668217922266321211219882279620750218992140884997D21380227662217584997A21731231402314121115217332156321564211662116482600232564758015056N15056BL21557226372213921033223852192822457849782316885099B2193020711224272238685099F21931207192071221929226612238322382207182308484997C2319223191231902316523167231662237946138B2320621559221522156346138B232062241122178219312213921929223862266385099C85099F22386207122237921175712702186747590B22766226612071923208475802238315056N207282082920726207242072322356212452124284997A84997B232052320885099F22386207122192985099C84510A2320422383232012209084509A85099C23208231992238621929207272071220718228962071923205207262072385099F2325622382207282238422139216702308415056BL2275284692227572275822756232052235620724207232072620725219292103385099F85099B8497875049L17129F8248422774227722277121314227782316815056BL15056N84849D82613D826002227884997A84997C71270712702115922663211692275221467211152143984997B84997D22891227582155784970S20829213802173122382220832111548194226612072722663207192303423035230332242722103714772238217129F82001S20685232042071923206207282319923201224112238685099B21928219312189984596B84596F2111521166215562117121163213802173115056N15056BL22083826002156484347212312208321559224112193185099C2308923084217311600882001S21137227552275621787214472204121175211792116923182211942120815056N2067921557223162319247590A211242319623197231982242622278223158505384596F2328523286232872328818097C228912235447559B47580231992266385099B17091J2257122572210332238647590A2156321557227522111082613D17091J15056N206792173123201223852316623165231632242623182226712303520829220452167322548217902267022409224072240622408224072217921980219832198522615224682198221984219672261647310M2071221137160084811185159A85159B219302071185014B82613D22671208292121120898218672275622753227582275722754227552262022139231822215121447212328248622905229042290323197162252319223190229082178747351B2238675049L223602303322426230352308921716217152277371477227732277422041217182142821672216692290816225224672066584347229052116922671231822319823196231971600885014B15056N15056BL21671216682152348187231682303484569A84569D15056BL15056N20711219302071282600207262072421669216682167121670216722310417129F2113722467824862124585099F2192922775232062238322384207271600821731231822319647310M208292113721718217152318222316227552240923166231672319823197223152231615056BL71459207331600815056N15056BL22316231822277547310M22178231672267084970L2221922139214242142623198231962319723198217542240622409219862179121790226702178721930223862319985099C226702198222409217872247648173C15056BL22755211372131347310M82001S2316822197220412231648173C15056BL15056N85099B2267523201225482318272802A2213547351B1600823198712702121021424214272142822406217182171621467231672308922315223642277817129F213137147775049L8497847351B23168231652284482001S21137160082275215056BL15056N22620217552175448173C21934226372308922409214302240722408224104748047471217312267022665221512275722756227582275322754227552319823197231962267221447208292217421428228918256782600211752267521425214272290422905229032179021791225482254916225224062171822560222972198721439218672065584997D84997C84997A84997B221392293922990214702070479302M21989217152171622134231542210148173C221782235221470216692277385099C2316723166223862071322674226752232622328223272232922410227552233322411207122193021929219342267522670226732267415056N15056BL2303123029230322302822758217872082922646226452318446118214282217922326227212236223403219282192922663207112241121930207122217322682226832268022681226842268522670226792268622677226712267222673226782267684406B2314723146231482082922427227582232684949221322213379066K2318247563A84912A221398483220655213292189921327224292194723016215312264422637221792116621867209862250085014B85014A213802275221684231842153023142228982289921523230892242715056BL21791222162179022904230361622522644226462192920711211662227822674226912269222414223652236685014A206792316921110850531622523190231922319122754226202278144089C44089A8434721327213292231822085226712290421380226282257185099B79066K2238621928475802268622685226812233122406843472266321561215592113720713233152331623317214272241023026231632189222310215302264422646232752264522757219342268321427212573592422227231972275522686226852267622671218822188022326214702303184970L2120721166211652232715056BL8434784510A208292213984509A2316822467231662316585159B217747145948184231692208385099C22411207122268622676226702267722679226812302923032227582327522409218122318221086223322233315056N15056BL16008226632193421121226802267623032221712267715056P2331622366226202231085014B2132921791213272117422326227582198721881223312227621530227562188221812218112186421866230312275722162475802233222333212574818479302M4818522678226832314715056BL2173122326232752303122677226862268023148222972290521232217902236684600215302303221811227552213917091J211372121022686226782268322682226762267722685212588460084510A23275226208434715056BL208292267421731222278494784347215582314822663215302275821012229042213921094207132246822905226792275822755230322217521530224262104184510A23147226718434715056BL21755215312263722386219342319622758222272155822904843752173122161226822267722678843472240723169224672125884947211372275522758231682327548173C849472242616008225562319722572225712213921879218832188121880226202193422426229622296322227221392314716008843478248684510A22753227572138015056BL15056N23031231462241115056N15056BL21773227572181122904229052290322227226852268222683226782267622671226772268022670226812268422686226792267222754227562275322673226752267423163160082318222310211212188384375231462186722175851502116421169851522117521530224682217921211211642198821557226204742120679220652296322962211372316823166231672238620712227782213922844219342193021929219282131375049L84945847924811182483824822266385099C224112217182001S217312143915056P21987843472206582486206852222723271223332115947559B2082923397481872181184347218922314821812220782101222227223652242623168207112179122152215302275422753227562275723317233152250072800E160082184422227231962318422310217872267421880218822192822663221792082921892843752242920712220832316922467725982222735001G211101601621949218998483684347211694811684970S2067979302M8505321012233972236547563A21470214282082923026232752238685099C224114818821169207182072485099B223278469223031213808520285204852032319784347233162331522265207132279415056BL2204121169843472278123315233162275584971S442354423444235227582275523197226912113721258224142152448116231692331523316233172179022678222622189222227217182171623184231962193185099B84347224108494523147231482240647310M79302M22905461188497822752212582332621313481872331723197210122222722794231822175585053231102116921258231682316721314211374423484347	25.54	4.144444	0.243316	-38194.0	419.714286	26.142857
9	16098	2005.63	87.0	7.0	613.0	1000221912218322241122379223812279822726229262283922838227832292622782224112091422381206812269022730227282272722381223792241122926230942241184673B84673A21888230802238122992224112272622730227272272520914230942299222411150392091484077227282272923315233162273022725227262272722728227292272722730227252241122726227262191221888847542321523214	29.93	47.666667	0.024390	-613.0	87.571429	9.571429

	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
5627	17727	1060.25	15.0	1.0	645.0	8505321928219292358123203229962300484978849462205122986232312354616156S215232269248187235972329822169221702309323408824822299047591D22965229892242522429224268505923243233372333523198219772330723295226242262722720232452297922980229782298122982229932349522722227232290723104225572255522556225512255423370233662143023236232402179022622	16.06	6.0	1.000000	-645.0	645.000000	66.0
5637	17232	421.52	2.0	2.0	203.0	843472148423356228162281823695220302077723439228662076620764228672286523494234932334422142229662208122991207612158421484843472357622144233192076123240224282286522726228672272723344	11.71	12.0	0.153846	-203.0	101.500000	18.0
5638	17468	137.00	10.0	2.0	116.0	2320422460212312259621070	27.40	4.0	0.400000	-116.0	58.000000	2.5
5649	13596	697.04	5.0	2.0	406.0	2262523345233462297823580231162285121136848422296184997A2236722899232752294921080232542171522450849922325622429223602329321877219758499123173220912327523289232902197223313233382296621592229552295122326218778498821034481872197523372229512241723296235752324123177235602334522630235082331322948224172295122630226292308423306232032339023494234932334323299227542290922910229032337122551235082248921878226232254921889225302254323320232852328823286232872308422534225442255623510233892294823598225632256222093227302340122111216152330722093234092337123241231932319421913230802242321888216212187822554226622238222499233902251622517225142251521715217182337284978231302244522450224462319723529216152319822489233722337123377849918497822485220912113622956232712246022178232452323922813231902274622748231772319423241232422179023367233462336823345	4.20	7.0	0.250000	-406.0	203.000000	83.0
5655	14893	1237.85	9.0	2.0	799.0	85183A2278220749222772193122380232022245722089216422331079302M2308222780230792231021314224232289422907229082227884912B2116717084N17091J2207522580235812149722438224392218170007217902170521703229602137722467229692110884031B84032B84032A84031A2236147421850662311085183B233532349285049A2290922818224568248485152825822117521174211812190821166219072315523200231992320385099F85099B23202	16.96	2.0	0.666667	-799.0	399.500000	36.5
5659	12479	473.20	11.0	1.0	382.0	21212212102108021086219892198721558212112121321882224378499222993226282121623243212172272021088219882109422215227342207785049E85049C20978209792097323370	15.77	4.0	1.000000	-382.0	382.000000	30.0
5680	14126	706.13	7.0	3.0	508.0	22274221502227322779226212245785123A2096122605224332147923444209632256020961	47.08	3.0	0.750000	-508.0	169.333333	5.0
5686	13521	1092.39	1.0	3.0	733.0	2353523301233002332022138228352211385177226512187823084851782262185039A21313219142145422620235702299323251218182181021819710502149435471D233272332621135230748497823367216842214422150218892179023189226592249484347216162162021615850592181821819221162117221905230602328121446234982342223420220912272784625A2301323014224812286322972229742332882551224022132985032A85032B85032C232932283122196210662299323293232942329521314224282218222961233682336523366235522349722196221952334023382230842259222842228402242922208222082220922211215342152821537359673596423163231622236747591D215922235222945232492325023251214942297722977210122348922071220702332022509223652277022605226072330123300219122254923526216192171384031B2067915056N229522211323356228352211122695221962295223295224242159284032B2339423396233952339321714233282353523536230892140121400233388498822190234942191422546851782318222673226712178721914210642255785231B232418505322118221192301923080848322308421718214942342222494840122329522642843752219621790219162212322942212792281122457224092240622398224002240021716224412296085061W2306023281234252241984707A22076220752247623169224742316935471D23328849472296423101231002341835970231682329522956234892263922642226382264323214218182181921810229562349523552234982349723296232932329523294212632250915056P20679206862217023084209922198421790235042209123376235062351022280222792295285176227272238923367225572255190214E2253022546225442254422533225342214422744227432349390214P90214I22651218782173921064207332198421705233002330122500216192308022940209722215085015150392262122500211152189121890220962275420996218942314421260213132138384993A848792113621718225222318985169A85169C85026B2249521494230742330922132220992339820986220972162085231B21976849918497822139214392267121172231882199321329235512110922119224732247422209224222339947469223982240223356221112283522113221102221022211222082144679063C22620231222163821640209752299322075220742207622481225632256222564222762207222109221082212484596B23252224752334022314229387000623368233662097522561229552247284819215912159284692359702264222343221962156322195215302197723123208682171522638226432321221162232812338223100218192181023212232152181021808218032295522956233202209422942	2.51	4.5	0.300000	-733.0	244.333333	145.0
5696	15060	301.84	8.0	4.0	262.0	22485224562346123090214942115484876B84877B215922199135471D85049A85049E235622298223100232752308422616229522125822597227342369485049A2202822209229522226635810B2161621619216158511185183A22500233952339422654231982235822507222782103485177233782261623376233782357117012D17012B2115485049E22734225858517685183A85049A225782257723359219912220922952222082337822597225782257785111226972346123090223782346185049E23354215922108022654231002327523352233512235823570221151625421616216152161935471D85032B223492234884877B84876B84876B2198085032C22754227552075520777223482339423395214282103422456206682245622030224022329123292234992191621991	2.52	1.0	2.000000	-262.0	65.500000	30.0
5715	12558	269.96	7.0	1.0	196.0	227122334485099B2320979191C233928482823158215072150822027	24.54	6.0	1.000000	-196.0	196.000000	11.0

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample